PlEmployerContactJobSkill 
Logical Entity Name  PlEmployerContactJobSkill 
Default Table Name  PlEmployerContactJobSkill 
Physical Only  NO 
Definition 
 
Note 
 

PlEmployerContactJobSkill Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PlEmployerContactJobSkillID    int  NO 
 
PlEmployerID(PK)(FK)    int  NO 
 
PlEmployerContactID(PK)(FK)    int  NO 
 
PlJobSkillID(PK)(FK)    int  NO 
 
SyCampusGrpID(FK)    int  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 

PlEmployerContactJobSkill Primary and Unique Keys 
Key Name  Key Type  Keys 
PK__PlEmployerContactJobSkill__PlEmployerID_PlEmployerContactID_PlJobSkillID  PrimaryKey  PlEmployerID, PlEmployerContactID, PlJobSkillID 

PlEmployerContactJobSkill Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
PlEmployer  Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_PlEmployerID_PlEmployer_PlEmployerID      PlEmployerID  NO  YES 
PlSkill  Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_PlJobSkillID_PlSkill_PlSkillID      PlJobSkillID  NO  YES 
SyCampusGrp  Non-Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_SyCampusGrpID_SyCampusGrp_SyCampusGrpID      SyCampusGrpID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_UserID_SyStaff_SyStaffID      UserID  NO  YES 
PlEmployerContact  Identifying  One To Zero or More  FK_PlEmployerContactJobSkilll_PlEmployerContactID_PlEmployerContact_PlEmployerContactID      PlEmployerContactID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

PlEmployerContactJobSkill Check Constraints 
Check Constraint Name  CheckConstraint